SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001974s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429673 LIMIT 1 [ RunTime:0.001209s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429673 [ RunTime:0.003055s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568202,818443,717519,1030275,102546,792566,648831,773589,1002741,763112,347906,531371,202018,378586,332414,431544,598103,531816,723973,304843,239436,803185,891777,983426,595232,830574,224457,473771,1047053,906385,537492,876717,393623,408735,838808,709687,697686,231071,260323,789872,37690,223845,27005,663213,184100,292547,894794,342008,71429,346817,548944,846987,267852,543544,1047980,378638,357478,65743,566986,430719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429673 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000879s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429673 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003755s ]