SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003022s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538056 LIMIT 1 [ RunTime:0.000931s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538056 [ RunTime:0.003929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51192,691245,299761,436473,56592,280567,696002,850779,866779,730425,352204,622751,363884,852344,742609,333512,788381,656075,1027675,225723,534862,770893,254711,1040518,912441,372472,954455,461270,774877,29845,657734,704675,496682,817866,560817,390131,777403,621442,415958,804427,767382,558274,718961,269921,240071,399084,528577,699043,742351,874373,387744,926737,438347,769879,425417,968722,204504,684681,328604,551885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001769s ]