SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046905 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046905 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339438,454792,979013,579872,816880,502215,31225,486383,261121,697593,132415,328591,477168,438780,729086,177287,576205,159972,405211,290641,582057,264760,819381,857698,526642,969906,94170,395368,156959,363860,266900,737994,516923,1019666,522265,864348,260972,305593,343398,580601,374440,450100,180007,308736,580673,287518,945747,802455,656600,1032441,697403,790866,84019,716047,197469,661325,810301,690637,293425,771854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001935s ]