SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010990 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010990 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263530,745295,97710,407040,792616,33376,440998,743608,781197,923669,33823,969902,53022,10294,305770,114978,39885,498724,241690,114085,83061,742854,357249,941852,346649,151504,611228,200447,110038,710089,659432,804280,734025,775143,37003,45278,939214,304335,552898,367225,312887,120848,332412,276355,443410,604692,604526,831215,592942,337779,5511,71609,973779,938052,426253,659380,48523,267797,697037,884117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010990 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010990 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]