SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397984 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397984 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181634,846075,971658,217032,412148,784935,188838,231328,894309,1045281,398036,325024,586574,1034334,909219,1000385,285766,1012358,180998,340781,121567,333387,33951,881608,967641,775086,498410,1003982,485067,945272,573102,340814,942539,184347,586983,820278,272355,158434,1011964,895782,782542,128779,448838,553400,570713,461731,264738,41108,180489,44881,638383,104777,472337,664875,507321,67839,116960,627950,343597,456310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]