SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027146 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027146 [ RunTime:0.002442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708291,271217,629384,992701,981218,650666,361560,662943,1034893,387733,681979,133442,967625,396125,925932,914747,218266,863591,923998,382032,188006,746647,129712,490062,445730,145312,463239,318461,109259,948935,637317,486108,714821,840405,289181,604388,950480,781964,776159,164129,134147,641194,828468,966750,498524,116499,795132,1025045,427312,645346,452387,22219,403206,187913,491550,46369,834811,1047664,336265,157922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027146 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027146 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]