SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002032s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 223178 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 223178 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042674,14703,1027820,417823,689539,184707,359068,554498,817538,531671,352964,630623,902661,25406,731936,535490,425205,158802,84294,933638,786160,637625,657660,301862,123557,259063,195871,908755,398048,192625,1022097,968276,110485,264665,615318,156484,850580,326830,198537,990595,285238,495769,223340,685135,834425,286978,381350,763363,462621,949659,381472,325945,674374,681858,676762,391509,826898,366504,184922,123799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 223178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 223178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]