SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504991 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504991 [ RunTime:0.002147s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559686,771202,680905,147343,180334,55484,927010,36972,317601,120561,477045,60493,138892,194350,684638,568112,479842,956150,440456,517255,522789,905574,828430,567378,879817,91235,968481,740975,392164,866419,510999,382425,673921,511214,786393,810893,644660,189562,335568,392448,547819,72655,538508,898708,937153,123952,908474,230518,887469,945195,496622,30869,532134,1028889,54473,813141,876037,115320,211942,209474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]