SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 691096 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 691096 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158021,109102,180954,762533,118746,899252,301868,428609,263324,686790,214296,644024,886648,757884,954544,339400,563751,276316,923351,946343,32907,811588,851424,71419,437179,937950,264011,568790,632187,57714,252843,83932,311400,830823,516689,176783,793376,284598,254177,267253,409405,801027,716313,559989,340005,469405,152045,700300,205989,607881,93309,629911,294467,807269,498567,920636,3415,187099,963865,310394) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 691096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 691096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]