SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532008 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532008 [ RunTime:0.001525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027187,575676,89751,510387,88998,767791,478423,338138,593059,95928,85062,629387,588747,883253,482680,975685,502398,701881,971196,126854,91013,89608,62416,331853,538145,730655,132564,725744,961209,671071,158593,844989,978338,128265,106132,511989,593698,452037,816708,874364,319218,618790,717454,700372,432470,182565,247750,495716,843397,273850,508232,883655,539033,775420,765420,864855,997647,19139,217762,525463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]