SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529880 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529880 [ RunTime:0.001835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421982,944980,372451,69291,355282,521210,34625,944981,824888,253577,40324,26517,549295,663432,812378,92454,798234,1018413,165807,751220,254616,1017341,207488,320530,512608,790289,78688,944034,917391,643063,480295,260661,233930,325694,626122,167012,196605,908590,602418,51747,645024,284655,757205,482011,323487,39201,335034,678798,313250,868358,441893,577826,609914,178651,143188,272009,190509,485582,739723,486257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]