SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458778 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458778 [ RunTime:0.003336s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764397,144886,13391,233443,162508,886033,1000961,387608,469278,306320,999109,71418,379568,132176,988396,170550,239780,156368,24873,622526,342539,687015,998847,643937,275703,510001,723865,295642,977613,402428,927297,181709,532361,686849,31939,388459,773501,749588,588835,690805,858035,348329,320867,395332,938100,215910,939336,446704,492251,42228,934017,224233,1030908,222562,368671,364958,615645,56716,384562,705461) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001691s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458778 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458778 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]