SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284140 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284140 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (990829,107189,205798,835721,943110,823542,51317,877881,369073,305140,1002564,761672,713917,830485,316152,876318,395112,196526,714481,557328,328464,275971,323559,423887,692015,5614,712676,375028,802626,675483,53705,428859,637013,115132,481148,43952,433424,873559,635733,102251,294099,209987,16249,61773,658455,7071,162836,629795,166706,534237,656988,908314,33035,893423,976024,688581,962015,650915,546468,340117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]