SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80190 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80190 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796078,422488,739903,1015341,206411,459088,873873,622908,943676,774554,1036124,278238,780833,97546,161784,172959,123803,165230,131256,404365,280764,199036,813855,868760,90095,1012131,296461,848092,228128,37023,853675,35760,261015,154326,373884,219494,810726,556121,314203,284521,143392,409602,393808,870100,750006,901361,756582,567748,897581,909108,465818,318152,893605,316782,754664,811872,684525,375930,548687,520196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]