SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004475s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545513 LIMIT 1 [ RunTime:0.003614s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545513 [ RunTime:0.003968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555849,1039203,336809,51970,474815,335456,677265,480891,897953,358861,418357,812612,653973,559050,297411,76509,1048871,437841,217499,946289,859845,1003705,310194,424507,573969,847673,621170,628766,368861,659360,385275,591797,89899,528849,101628,68227,301355,51784,401991,47335,155233,310031,347583,238004,638493,684102,328053,650168,217600,786416,526111,114809,208743,575016,1015614,132803,345929,202244,701414,892103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]