SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480511 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480511 [ RunTime:0.002040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642797,700375,453030,656069,946869,448509,73611,965670,562106,979498,777973,621887,904736,427309,150075,887705,559253,33045,918718,403658,89198,182564,151013,27643,831041,499131,1031765,1005964,970038,339048,111930,419091,201775,465071,916159,459758,813548,728713,832785,900767,326926,110017,92772,664348,670626,282222,15658,271504,800427,907047,259987,1295,110897,549765,810856,345080,36902,626463,580500,18516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]