SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336585 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336585 [ RunTime:0.002668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611612,972672,677270,69221,212106,611063,812966,270833,430078,1024741,133874,392345,862569,334608,205382,755643,528150,788497,649495,767590,719013,353561,171108,772042,342863,681545,132861,102700,829433,170936,532240,394953,124957,944191,252266,319177,280039,1000692,371057,544987,617978,433102,459518,565248,297182,798995,411988,753256,232337,941521,843433,976333,66088,253922,763711,820614,907967,744317,51896,748071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336585 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336585 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]