SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305606 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305606 [ RunTime:0.002782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220259,455775,485664,271072,222597,8648,923698,684993,104590,402869,702062,399543,182625,620318,349006,933372,1045015,144407,12252,257386,109145,674390,65164,604935,482387,567601,731350,796846,252790,885119,164888,443674,164232,235809,52988,176652,323445,748940,308549,78313,901168,859293,1007916,955829,500885,295037,652354,779483,956487,53465,793882,299930,340668,182440,265179,544656,959258,922108,14595,368484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305606 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305606 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]