SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002597s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 274103 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 274103 [ RunTime:0.001958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434525,100436,819041,456716,970724,432820,222963,122359,1008625,941564,111253,612339,809379,1002646,602551,385766,399426,69668,365390,181894,971753,591221,869794,327440,879238,672670,1034316,386498,164381,198538,811248,28167,921726,933547,175817,422543,1024492,308468,1037646,191187,1006124,259137,786704,448523,671971,362439,870085,177498,103826,150928,336424,58275,284374,98130,14464,358202,299044,285689,138927,681657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 274103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 274103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000727s ]