SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286216 LIMIT 1 [ RunTime:0.000533s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286216 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (828610,983642,988325,131932,116421,162851,308563,890599,741219,769654,959628,85844,1042852,466987,213175,668524,720510,845486,573670,568418,820113,487387,252579,229749,105787,277862,338067,477290,470358,968590,508436,553045,928266,49290,316275,131445,32654,962727,993283,737670,971869,674194,129939,1046038,776586,783425,720832,503953,171740,286266,781593,184802,163682,937012,749109,131988,482726,824992,364757,608152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]