SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 112012 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 112012 [ RunTime:0.002046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014884,116367,1003190,909081,717209,286102,477551,605878,746924,67896,119127,493048,554382,924742,575335,599147,545779,498632,506136,504016,562913,735423,708025,943836,683590,297938,676190,252869,19873,513274,487302,370661,974247,480719,468747,517743,58038,637025,986667,177838,105610,973505,700015,985448,96666,211595,816442,862619,541822,363554,613385,699923,968564,280411,178735,661284,908385,86526,508145,852553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 112012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 112012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]