SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20162 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20162 [ RunTime:0.002171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343363,848867,690726,582072,216208,273958,150731,596365,201573,664743,88563,379367,832748,114988,595245,327047,1045990,810687,6207,325119,889238,502665,50750,481050,766928,671775,114975,410318,113389,372278,977181,513692,241514,257954,985719,433503,534884,450117,988114,964598,883633,787372,235347,505310,468919,44160,746944,372819,143262,451505,57299,490311,27872,807186,484065,485166,364331,27269,268551,626249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20162 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20162 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]