SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261270 LIMIT 1 [ RunTime:0.000531s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261270 [ RunTime:0.002524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447788,749557,338433,198780,567721,99272,423488,627063,939650,731638,384049,268985,963430,651938,550879,477047,10573,777255,166414,34751,794618,258401,655064,415966,586909,108337,925916,626109,816928,816757,303606,723193,125694,24020,198817,875278,411480,500571,110079,476234,270852,314842,198140,348088,834154,815952,965677,372559,703666,607414,661184,577213,337738,798596,1030261,801604,346925,761744,1018029,111782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261270 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261270 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]