SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491988 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491988 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (973030,117366,962026,121777,808162,266526,767317,956769,239148,293774,1021596,853569,1040754,791258,325878,302626,637638,583805,737824,553486,905008,25166,216797,346608,687118,606061,481754,121146,873970,868662,551567,57953,456067,389740,129604,912495,816290,671308,529759,642801,514926,965890,449658,56753,978424,949263,498114,108205,395399,129599,735291,546348,147484,16032,136766,155727,764932,796677,575591,457101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]