SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001471s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503147 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503147 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964689,881158,728766,243687,694961,195438,721961,112830,497932,436767,396998,721411,369528,435787,864458,427201,517369,932977,800756,83160,252930,210939,641841,691284,127416,785916,591172,707609,639413,779086,10590,330790,793337,598307,262241,684121,745044,663097,221652,374057,328500,136837,567001,185681,655283,597251,402367,382199,824838,690111,559880,610356,783849,837924,872858,519323,973085,731404,937051,92921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]