SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3440 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3440 [ RunTime:0.003052s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927576,199983,1047121,96080,54835,1032487,611156,925654,660871,702992,626391,800562,995997,641195,622785,933847,413688,551823,501418,773722,197234,644742,28032,245529,123410,1025825,600749,274026,400242,428718,28367,832137,1038920,222742,683971,119266,407393,864314,870209,395984,512252,1023711,161249,128466,649967,125132,58063,108710,344747,536629,1022363,987201,500275,198942,201461,353191,584201,305322,1004781,178786) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]