SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 32941 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 32941 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303127,650564,1003101,431517,864880,443220,1008523,918266,247169,1016292,550027,83654,385870,292308,253277,160236,235696,792919,769603,438202,376572,1021095,808550,236252,921075,561560,50624,288413,946537,796035,382380,253997,359788,405638,103146,1021638,153795,10813,517902,850667,361711,11345,567920,5659,164457,902719,990146,320953,346274,177927,330594,931566,863994,985939,87729,180426,89166,275062,697748,192403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 32941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 32941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004103s ]