SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45391 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45391 [ RunTime:0.003172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (609717,750876,380103,560800,538671,959918,946423,823885,896146,745223,823091,40944,930545,369444,645789,1033271,84927,745053,720935,447384,864644,863364,1021207,805054,456715,865893,969944,432965,1036618,682101,308820,554454,653901,785694,612130,959797,648658,957918,816671,652902,50330,145173,1021070,130658,776324,783033,431463,125198,701084,594969,48606,800722,478475,433836,687699,263391,785273,809963,206496,951753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]