SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036968 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036968 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971447,1013760,820303,133744,788156,377488,51173,403223,188499,343966,364109,823113,904243,945298,410766,905810,652825,735752,219169,552629,977182,461116,962134,526045,414186,478568,213885,435440,785664,801531,531668,50548,176987,728178,935413,520330,832037,81879,312560,1009766,928039,715350,330482,192358,984029,194724,854424,98089,802746,503642,336878,711994,1002954,864974,149530,423281,255944,354192,738511,69033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]