SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408906 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408906 [ RunTime:0.002217s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403919,115267,863336,622148,1005932,356856,199693,208557,130485,888985,505032,430835,531761,734148,266224,909233,712633,700966,965808,946964,674902,521905,477537,126905,961970,773937,537453,567778,72223,688444,523150,649265,311487,17562,598988,149395,272983,965371,954002,470082,861186,190775,695793,512405,571888,896809,188121,144784,337961,780353,576677,559366,979366,143200,826150,200806,123432,789633,119198,72088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000905s ]