SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3248 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3248 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521450,676601,560453,373260,675610,644510,852716,14979,334600,720099,803872,837790,231531,656085,537786,891845,28696,1035140,801958,1016175,502621,369840,929557,30480,169872,52987,432531,108728,224918,517926,14037,1036788,1040036,24580,325660,791164,105797,310370,679367,927374,316406,214142,273906,136485,504387,933950,1043735,34501,211031,851460,946668,517152,750797,295750,528383,590842,725876,437939,371697,451906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3248 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3248 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]