SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485505 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485505 [ RunTime:0.003302s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (758824,994858,488360,140655,661966,331392,634324,833572,175574,195313,1036909,318109,412147,870686,756322,195830,133433,546392,951396,376064,131993,659926,931646,501477,96827,284083,571244,194291,469926,374610,906588,103662,966734,978683,786546,920280,310581,729960,1009882,800243,205814,678483,196612,923763,496000,798187,980287,489981,319898,798706,164316,335324,127384,931645,376939,60881,288763,693841,82925,899249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]