SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001552s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423323 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423323 [ RunTime:0.002058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904692,828911,233313,696424,257600,766582,758200,899383,568463,1020735,481182,35495,188317,128739,767965,688447,124053,570607,33443,242602,525958,910253,520427,506569,646739,211104,923069,283940,103907,720317,500222,243376,162124,362031,594086,601071,548838,803968,34003,872545,233361,462744,947476,13605,543614,199150,97936,927027,531411,1003730,708961,171667,848442,812695,2647,502810,358432,859121,864049,232721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001768s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003584s ]