SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 972305 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 972305 [ RunTime:0.002759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401129,589646,765903,792430,594023,21186,276148,348021,970616,384155,346556,948865,664383,720564,369832,129997,178025,210353,735130,371619,747478,640860,932615,347599,260197,62711,115479,452235,1031842,151452,657453,823850,401789,421794,442259,929575,485645,449040,280038,648288,141980,485470,395205,332475,774363,292254,769694,580498,628961,438290,270925,233905,734891,200684,534183,820237,204360,98727,44797,92291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 972305 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 972305 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]