SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469871 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469871 [ RunTime:0.002594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (30715,902696,363902,1034816,466576,295248,879997,1040914,54960,805161,737528,520106,464422,210049,584223,1009315,119701,455107,20100,791040,148757,271517,208724,162262,67073,825645,36671,68939,454807,981007,920026,982654,726514,974082,410265,1009623,100154,224034,974005,40618,561486,1002925,868189,784120,1005219,955000,494509,711461,990656,846195,986231,384764,552918,938599,433304,751319,337261,589142,191604,831066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002977s ]