SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438946 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438946 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190382,126420,263692,334889,288545,1035341,141517,286057,726825,922125,79166,975121,696486,677181,188776,927245,821036,683234,740749,174438,308054,315108,19416,219770,539753,205295,929060,879985,883199,56071,873192,972016,307887,131456,821363,987323,389667,441150,971540,262512,228584,169235,38071,346999,221742,321268,148668,60406,459866,687429,98230,79497,310584,362486,842039,954967,64728,636976,497637,490954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000385s ]