SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555399 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555399 [ RunTime:0.003283s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49310,269627,693479,144163,1042739,475403,60382,464849,584866,233573,779717,695576,978442,678124,667091,790841,714335,638841,223482,206693,508009,1010591,995079,608928,587760,796757,1015018,1028266,637692,162772,111303,703058,607595,1007878,65494,271234,299184,937897,96795,384443,586593,96786,135481,847220,1033813,230249,480912,254658,593836,486721,23562,623030,497712,438279,490112,1043731,662256,466682,166113,339482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]