SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474940 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474940 [ RunTime:0.002250s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734396,70044,683635,142566,234078,226744,545092,461676,249712,88870,132409,4976,88992,310469,520953,969611,263551,64351,75202,290060,822070,415105,344910,384067,141883,1019566,720398,264767,248028,468044,978399,355052,664351,32148,705273,760379,516398,57366,350734,482009,275083,973141,778087,1040414,756296,614659,280407,761054,891622,11856,166,190400,554645,817929,555680,454710,315094,486251,79567,737724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]