SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469611 LIMIT 1 [ RunTime:0.000586s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469611 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530101,554112,910807,790699,625280,77053,295958,120960,1046594,214970,250413,639948,535843,775577,19009,79843,495357,69136,902708,412557,759272,722605,181438,1012811,210003,223040,61103,751246,617234,403610,876119,361438,641965,786829,1020941,88993,845314,675846,268037,883855,479242,406450,595068,567629,137707,808756,949077,265277,996827,114864,1020954,499457,840145,270697,8685,297067,387782,237920,957982,275109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]