SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001497s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406776 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406776 [ RunTime:0.002497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017806,496987,256732,218597,694008,103816,916254,375692,701250,232795,1007814,507305,582073,507219,702430,166955,31637,638881,268203,926014,362234,1041619,884032,865375,489547,250487,1025470,671105,297801,78534,712252,1018254,931362,105274,116379,383432,608827,369826,735291,943440,801100,361303,926371,50242,363846,261586,687375,921178,196309,756961,48607,54210,266438,208050,511769,392672,816137,446363,231302,827085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406776 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406776 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]