SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047482 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047482 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187063,555707,865803,177083,941803,1002559,531997,562954,545904,466970,623990,243914,806504,835922,780615,313293,683444,29990,435651,433296,952009,280981,965047,940304,920704,647247,751724,713413,845292,803717,114655,128668,365482,310712,597067,900999,181375,781606,330318,199845,975562,355049,664849,798310,424160,702083,983002,425161,935904,629066,603646,476444,794833,424774,388980,457974,538056,164100,308743,151110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]