SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43106 LIMIT 1 [ RunTime:0.001148s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43106 [ RunTime:0.003594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (178962,584560,121902,1027784,513801,895314,1002300,990851,143020,592900,300937,1007578,19921,659791,485662,350196,234986,861374,976209,789844,772176,614112,73797,144865,966124,705106,254103,351808,175401,899150,384770,218590,478614,217993,508612,999215,862018,332398,159758,306882,92840,173583,1044477,7364,497213,364171,897783,390069,309741,168488,765372,250691,171854,736094,408080,573344,541036,785845,242251,1041047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001819s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]