SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513954 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513954 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (906150,336020,268637,653106,495109,364547,1541,484353,559345,82093,465595,765966,723341,965959,625653,527158,4816,783560,123579,450063,82717,57064,634568,340658,234438,812836,210522,278677,525113,805820,116582,810676,349417,537654,383167,793262,740072,503897,930964,100619,704196,896595,119470,56816,817645,113173,457871,562508,587497,269389,696678,373642,556029,97405,142955,48779,351539,286706,1031889,78349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]