SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401748 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401748 [ RunTime:0.001532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237807,488790,615350,349944,914167,429882,804368,93328,999080,536716,395175,180991,427333,763006,195453,765945,630491,514674,1037099,947228,343286,207080,918075,844025,919024,653669,878417,510956,95536,46338,544445,1033839,33810,827634,151488,704919,379952,636532,196814,293342,286549,45457,2958,833053,806981,331871,213868,165174,985623,993354,577528,150037,632879,668396,400862,170031,877497,567560,463027,253951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]