SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002436s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804014 LIMIT 1 [ RunTime:0.000680s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804014 [ RunTime:0.002186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29493,916548,271987,112314,179010,529716,782952,553404,145946,411643,393146,501169,785010,920175,317090,760211,41994,985821,839875,443539,290921,667268,314364,202552,109653,525781,103334,1034642,12797,635106,591038,212370,255846,799873,150038,734705,577389,961572,975408,604597,391956,291347,883092,401566,420517,346647,186899,278518,1006573,393840,895595,413984,713224,739352,377244,512252,234953,489654,397376,268835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000891s ]