SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531110 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531110 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286358,998630,686310,173807,176962,174247,850312,501622,799914,1041828,362355,1041569,8721,374088,1000718,872502,859607,854773,367022,750020,867196,847172,437427,76219,441307,660801,217737,670520,212837,529735,1014107,703900,827164,110603,615371,865223,753776,710487,774619,185618,889504,1014187,280668,1039253,2370,38301,586472,438668,445928,401881,567962,876675,925820,160800,502321,589821,820362,774402,905984,194704) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]