SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591311 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591311 [ RunTime:0.002139s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998191,1000870,831519,803073,249820,181788,400991,944811,325302,796268,978286,834023,186156,656137,768705,503624,172654,1034573,453670,426403,896229,123193,150513,942205,755148,529541,428213,348242,87536,29156,630948,31238,566169,183861,1045917,724556,455691,249628,685361,460719,257667,522150,689888,768443,737883,160585,875115,957918,423952,579258,505990,887558,368246,122977,758418,328800,640312,671691,118370,32937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]