SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 75018 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 75018 [ RunTime:0.001498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10139,1019357,797424,264557,691058,217726,156107,984612,434042,761644,730288,35985,284318,574422,201092,634767,390715,665067,569015,701977,340854,182712,496006,121754,516650,169243,1020441,961887,474284,446021,597368,45199,240181,557721,56669,467669,641088,354380,396008,703939,852874,860226,1006849,667782,5291,300535,660586,719926,734023,403810,1018301,839724,418867,755478,665167,73842,614956,521259,273343,358344) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 75018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 75018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]