SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502369 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502369 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532548,417830,320449,51019,550652,984549,267670,265260,820601,215034,384157,249789,27639,1017804,922400,864217,159141,755625,545132,944434,938067,767513,660359,468958,989095,327006,572149,785917,264457,893756,350512,140095,541797,458378,557230,143194,1028342,140966,1045001,2486,781394,633461,132345,586861,612147,160091,375555,223672,894884,892461,239878,812685,909350,983967,322683,738118,891072,409986,326358,266277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502369 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502369 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]