SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045160 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045160 [ RunTime:0.002906s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215520,696281,707558,411832,469588,231307,403773,137391,438864,655595,675509,473875,265340,466423,478252,786335,1022959,232961,98013,133107,794120,283399,539445,412806,677267,555414,128381,2691,308278,428929,809131,650817,212904,936187,124393,1003618,485525,561421,657409,997890,37135,77544,712107,924885,315470,241161,323828,369616,256138,181902,611861,563319,238138,3711,773151,831525,820119,494814,175182,470868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001497s ]