SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481806 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481806 [ RunTime:0.001471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503774,121589,142531,468884,891057,223311,640595,590552,217269,70983,451324,826946,9589,993545,918967,879801,575929,155343,500667,722056,341542,109160,799674,681914,822847,856018,464876,680437,890928,998643,727106,655326,293408,548742,435441,996850,920001,596419,824131,511118,221181,801663,1007968,932077,105076,567677,92749,716145,1028508,258525,26916,551765,959692,800693,615636,164202,409323,907102,52075,432145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007735s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]