SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.009952s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341883 LIMIT 1 [ RunTime:0.007456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341883 [ RunTime:0.002539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (746731,444873,71293,253063,313859,1012592,255976,502935,84638,117801,559673,930546,244787,397626,171731,592107,280324,404085,673420,365881,971029,589891,219856,113896,673753,282009,940168,660801,400583,389307,768518,632452,1046682,342267,48151,874765,589707,198464,734115,585591,71224,98814,273544,1043507,65129,566949,691362,176961,543619,866762,630645,818848,80536,791032,297515,155832,1028047,300282,16654,506492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003692s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003373s ]