SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536594 LIMIT 1 [ RunTime:0.000546s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536594 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391561,481871,592975,10023,767735,13437,777411,593430,590797,823716,1030509,489610,288416,233124,374651,1014322,431606,89572,987705,564583,1038710,806507,132819,354684,483305,93325,589480,42567,839117,205308,834671,48367,271365,769086,592466,84289,719818,180350,85989,560048,120206,416047,45898,270970,469607,298174,289508,671998,164571,809656,967930,10271,316749,390466,404070,410055,16247,628826,695271,352978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536594 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536594 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]