SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53340 LIMIT 1 [ RunTime:0.000494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53340 [ RunTime:0.001947s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346222,287609,825906,227573,882485,528139,402540,404073,855905,400726,686118,352375,388278,255622,50688,586586,576375,985980,736020,621599,166369,856460,892941,452154,663602,1023333,589412,581424,653756,286412,193424,507322,991214,251748,200633,91981,147499,858189,823674,880944,604302,995644,11597,256801,693122,555353,821014,97002,866247,801694,607188,411937,894189,557886,924068,82057,100453,109328,876509,399645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53340 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53340 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000735s ]