SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149875 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149875 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422219,448964,477826,997436,536678,227069,359807,202037,511629,504309,77543,77123,719404,933320,1015671,428291,215008,476112,225479,593734,487319,354902,231378,398387,400851,356371,811509,777772,356658,535763,92061,552389,205655,795113,309375,798819,569569,853273,840894,562948,226023,977781,687781,122121,190016,515237,616940,298605,787797,658239,342725,906604,497540,190131,16297,610858,776420,274267,159327,742926) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]