SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262722 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262722 [ RunTime:0.002586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520013,379940,970780,361964,839020,671144,705835,769187,33633,1028669,710759,507653,22245,265625,860839,724375,573190,827271,609685,319584,323455,656560,633400,614759,278882,653690,392239,906513,171855,205676,190256,226784,858915,704759,109153,94779,133915,738812,253322,431555,45078,543649,78697,866602,574179,1048347,55804,316732,411449,523514,469536,196351,387802,1000906,860835,129746,781661,839967,40974,1043367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262722 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000642s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262722 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]