SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034567 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034567 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47793,104969,329187,26371,139267,384020,423714,407273,974226,409777,884494,133164,366687,704253,573209,40124,35596,372050,886369,589615,830650,625726,268283,386775,21445,31094,392828,87654,395708,448345,899868,74602,816679,91100,756338,278421,429516,118084,906037,22555,264685,722813,505973,835434,284099,927857,782597,640956,180984,478581,21100,287549,588993,414248,381554,241,497706,563391,97882,605120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034567 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034567 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]