SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001689s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543281 LIMIT 1 [ RunTime:0.000931s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543281 [ RunTime:0.003347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768215,726961,595610,379833,410289,932759,211686,889206,284742,345286,1008650,996229,381026,828328,675977,291231,1022892,831046,286860,226199,875731,391256,232037,961930,621916,312220,369050,823106,733174,423933,328478,99835,31224,403338,362426,824024,498157,157352,678527,1024177,762150,735017,933256,662520,822525,611963,145189,432675,75017,333076,1029065,282954,1035833,362695,159653,573119,663933,643258,646771,322561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001950s ]