SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003702s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 271810 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 271810 [ RunTime:0.002761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (817111,746296,633693,728312,402913,561902,1037079,338243,120540,971825,304640,477319,442489,199581,1030660,27208,78719,189625,391624,667751,673936,500901,53535,626769,138637,258429,338737,925276,247686,228726,158708,51088,1037292,943157,27868,807361,424110,825467,184288,657780,781653,136417,722511,307026,797783,57766,281614,523835,704577,1002091,889933,995343,650332,386387,962507,957941,796424,987250,159437,479687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 271810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000806s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 271810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]