SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433412 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433412 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137513,384580,1002783,796903,1010295,62397,664389,140499,1024946,1012842,699156,166945,912052,981617,955063,556863,202733,10060,887250,426093,42468,717886,1465,917178,51614,649068,246668,29018,547639,263065,46842,225969,259863,837274,652687,607935,123076,913782,386559,583555,412701,641913,105934,815604,133813,791689,151437,842782,138930,437705,186027,110072,666960,503116,1004351,588889,1007546,121752,892797,1019787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]