SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001423s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451845 LIMIT 1 [ RunTime:0.000591s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451845 [ RunTime:0.003858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542831,828700,148771,257710,812231,369633,711602,403011,676252,633496,496982,46806,236213,12629,555739,529522,990596,890878,549985,454875,214490,721674,975994,350623,420233,671520,749401,182891,1025367,681058,393049,487628,520611,109518,663160,851038,733405,305929,428268,688169,136343,728729,794744,900125,276121,902836,341329,772068,416020,328214,47252,560390,203787,975165,417147,948796,580015,920910,112590,846965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]