SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001549s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301071 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301071 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549314,503506,260125,544821,1047229,205516,694303,577307,911387,429885,528359,690061,930006,998816,761839,162578,987130,428724,55630,852934,404525,528571,505366,148910,867738,678690,724060,585976,861364,21029,79257,861456,694810,623488,43304,587294,947339,599119,255328,264957,1042443,177564,921107,440663,170629,146427,640579,234855,756985,747325,335886,911283,1006457,326743,1009241,184949,344837,331594,1025094,224998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]